﻿
namespace ErpToCrm.Config
{
    class UriConfig
    {
        // erp data base
        // public const string ERP_BASE = "http://ldcrm.liando.cn/customize/page/ab125ee89/nctbht.jsp?sql=";

        // 测试
        public const string ERP_BASE = "http://ldcrm.liando.cn/customize/page/ab125ee89/nctbcs.jsp?sql=";

        // erp data source {销售合同}
        public const string ERP_SOURCE_XS = "select * from v_ld_crm_bill_sign where nvl(dr,0) = 0";

        // erp data source {销售合同}
        public const string ERP_SOURCE_XS_COUNT = "select count(*) as count from v_ld_crm_bill_sign where nvl(dr,0) = 0";

        // erp data source {租赁合同}
        public const string ERP_SOURCE_ZL = "select * from v_ld_crm_bill_rent where nvl(dr,0) = 0";

        // erp data source {租赁合同}
        public const string ERP_SOURCE_ZL_COUNT = "select count(*) as count from v_ld_crm_bill_rent where nvl(dr,0) = 0";

        // erp 查询人员档案jobnumber
        public const string ERP_QUERY_JOBNUMBER = "select * from v_ld_crm_bd_psndoc where pk_psnbasdoc = ";

        // erp 分页数据查询
        public const string ERP_QUERY_XS_PAGE = "select a.* from ( select t.*,rownum rowno from v_ld_crm_bill_sign t where rownum <= {0} ) a where nvl(dr,0) = 0 and a.rowno >= {1} ";

        // erp 分页数据查询
        public const string ERP_QUERY_ZL_PAGE = "select a.* from ( select t.*,rownum rowno from v_ld_crm_bill_rent t where rownum <= {0} ) a where nvl(dr,0) = 0 and a.rowno >= {1} ";

        // crm system account id
        public const string CRM_SYSTEM_ID = "0052017BE8702F1PIi4j";

        // crm username
        public const string USERNAME = "admin@cloudcc.com";

        // crm password
        public const string PASSWORD = "Liando123";

        // crm data base
        public const string CRM_BASE = "http://ldcrm.liando.cn/distributor.action";

        // crm data source
        public const string CRM_LOGIN = "?serviceName=clogin&userName=" + USERNAME + "&password=" + PASSWORD;

        // crm cqlQuery source
        public const string CRM_CQLQUERY_BASE = "?serviceName=cqlQuery&objectApiName=contract&expressions=";

        // crm data source xs {销售插入}
        public const string CRM_INSERT_CONTRAT_XS = "?serviceName=insert&objectApiName=contract&binding=";

        // crm data source xs {小产证插入}
        public const string CRM_INSERT_CONTRAT_XCZ = "?serviceName=insert&objectApiName=czmxb&binding=";

        // crm data source xs {租赁插入}
        public const string CRM_INSERT_CONTRAT_ZL = "?serviceName=insert&objectApiName=zlht&binding=";

    }
}
